SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE [dbo].[usp_UpdateCollInfo]
    (
      @fdCollID VARCHAR(50),
      @fdCollName VARCHAR(50),
      @fdCollIntroduction NTEXT
      --@fdCollVerifyStatus BIT,
      --@fdCollVerifyTime DATETIME,
      --@fdCollVerifyID VARCHAR(50)
    )
AS 
    UPDATE  dbo.FS_College
    SET     fdCollName = @fdCollName
    WHERE   fdCollID = @fdCollID
    UPDATE  dbo.JOL_CollegeIntroduction
    SET     fdCollIntroduction = @fdCollIntroduction
            --fdCollVerifyStatus = @fdCollVerifyStatus,
            --fdCollVerifyTime = @fdCollVerifyTime,
            --fdCollVerifyID = @fdCollVerifyID
    WHERE   fdCollID = @fdCollID


GO
